Skip to main content

AnyDB Report Cell

Report Cell Type​

The Report cell is a wrapper around the REPORT function. It provides an easier way to build record-based aggregations without manually writing the full formula each time.

You select the aggregation, type, and field in the cell settings, and AnyDB generates the underlying REPORT(...) formula for you.

The REPORT() function also supports an optional array of filters. For now, Report cells do not provide a dedicated UI for filters, so users must add or adjust the filter array directly in the formula expression.

Report cells are useful for:

  • KPI cards such as counts, totals, averages, minimums, and maximums
  • grouped summaries using terms
  • inline charts powered by report output
  • operational dashboards inside records

Supported Output Modes​

A Report cell can display the result in different ways depending on the report output and the format you want:

  • Text
  • Number
  • Currency
  • Percentage
  • Chart

Simple aggregations such as count, sum, avg, min, and max are typically displayed as text, numbers, currency, or percentage.

Grouped terms output is commonly used with Chart display.

How It Works​

When a cell is set to Format = Report, the Report cell settings appear in the right-side details panel.

Typical fields include:

FieldDescription
FormatSet to Report to enable report cell behavior.
AggregationReport operation to run, such as Count, Sum, Average, Min, Max, or Terms.
TypeThe record type to report against.
FieldThe field used for the aggregation or grouping.
Display AsControls how the result is shown: Text, Number, Currency, Percentage, or Chart.
FormulaThe generated REPORT(...) formula. You can review or refine it directly if needed, including adding optional filters.

If you need more control over filters or advanced logic, you can edit the formula manually.

Adding Filters Manually​

Report cells support the same optional filter array as the REPORT() function.

For now, filters must be added by editing the generated formula directly.

Example:

REPORT(
  'count',
  'Project',
  'Stage',
  [['Status', '=', 'Open'], ['Priority', 'IN', ['High', 'Critical']]]
)

This lets you keep the easier Report cell UI for the main setup while still using advanced filter logic when needed.

Basic Aggregation Example​

To display the total value of all Project records:

  • Aggregation: Sum
  • Type: Project
  • Field: Total Value
  • Display As: Currency

Generated formula:

REPORT('sum', 'Project', 'Total Value')

This is useful for dashboard-style summary cells such as:

  • total revenue
  • open ticket count
  • average deal size
  • percentage completion

Grouped Reports with Terms​

When you choose Aggregation = Terms, the Report cell returns grouped output from the selected type and field.

Example:

REPORT('terms', 'Project', 'Stage')

Example output:

[
  { "key": "Enquiry", "count": 2 },
  { "key": "Completed", "count": 1 },
  { "key": "Delivery", "count": 1 }
]

This output can be displayed directly as text, or used as the source for a chart.

Using Report Cells as Charts​

When Display As = Chart, the Report cell uses the same chart configuration model as a regular Chart Cell.

The difference is that the chart reads its source data from the current report cell output by using the CURRCELL reference.

This is especially useful with terms reports, because the report output already contains grouped values.

Example​

Suppose your Report cell formula is:

REPORT('terms', 'Project', 'Stage')

This returns:

[
  { "key": "Enquiry", "count": 2 },
  { "key": "Completed", "count": 1 },
  { "key": "Delivery", "count": 1 }
]

For a chart:

  • X Axis Labels
MAP(CURRCELL, 'key')
  • Series Values
MAP(CURRCELL, 'count')

This lets the chart use the report output directly without needing a second helper cell.

Chart Settings​

Report cells in chart mode use the same chart settings as regular chart cells, including:

  • Chart Type
  • Chart Title
  • X Axis Title
  • Y Axis Title
  • Orientation
  • Series Name
  • Series Values

For line, bar, and pie chart behavior, see Chart Cells.

When to Use MAP with CURRCELL​

Use MAP(CURRCELL, ...) when the report returns structured array output, especially with terms.

Common mappings:

MAP(CURRCELL, 'key')

Returns the group names.

MAP(CURRCELL, 'count')

Returns the grouped counts.

This pattern is the easiest way to turn grouped report output into chart-ready arrays.

Report cells work especially well for:

  • open vs closed counts
  • project stage breakdowns
  • sales totals
  • top categories by frequency
  • status dashboards
  • lightweight embedded analytics inside records

Notes​

  • The Report cell simplifies report creation, but it still relies on the same underlying REPORT() function.
  • You can manually adjust the generated formula if you need advanced filters or custom logic.
  • For chart displays, terms aggregation is usually the most useful option.
  • CURRCELL allows the chart configuration to read the report result from the same cell.